Tabela LPerfServiceComments

Definicja tabeli LPerfServiceComments

Name

LPerfServiceComments

Code

LPerfServiceComments

Comment

Tabela przechowuje komentarze dla danego PerfService-a. Jest potrzebna w module podan leków aby wprowadzac uwagi pojawiajace sie podczas podawania leków pacjentom.


Lista kolumn tabeli LPerfServiceComments

Name

Code

PerfServiceID

PerfServiceID

LPerfServiceCommentsID

LPerfServiceCommentsID

Comments

Comments

InsertDate

InsertDate

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

InsertingPerson

InsertingPerson


Kolumna PerfServiceID tabeli LPerfServiceComments

Definicja kolumny PerfServiceID tabeli LPerfServiceComments

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LPerfServiceCommentsID tabeli LPerfServiceComments

Definicja kolumny LPerfServiceCommentsID tabeli LPerfServiceComments

Name

LPerfServiceCommentsID

Code

LPerfServiceCommentsID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna Comments tabeli LPerfServiceComments

Definicja kolumny Comments tabeli LPerfServiceComments

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InsertDate tabeli LPerfServiceComments

Definicja kolumny InsertDate tabeli LPerfServiceComments

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedDT tabeli LPerfServiceComments

Definicja kolumny LastModifiedDT tabeli LPerfServiceComments

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli LPerfServiceComments

Definicja kolumny LastModifiedPerson tabeli LPerfServiceComments

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli LPerfServiceComments

Definicja kolumny InsertingPerson tabeli LPerfServiceComments

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Lista kluczy tabeli LPerfServiceComments

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPerfServiceComments

Definicja klucza Identifier_1 tabeli LPerfServiceComments

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment